object fmMain: TfmMain
  Left = 332
  Top = 132
  Width = 894
  Height = 521
  Caption = 'Ebay search tool'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  Menu = MainMenu1
  OldCreateOrder = False
  Position = poScreenCenter
  OnClose = FormClose
  OnCreate = FormCreate
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object StatusBar1: TJvStatusBar
    Left = 0
    Top = 448
    Width = 886
    Height = 19
    Panels = <
      item
        Alignment = taRightJustify
        Width = 150
        Control = JvLED1
      end
      item
        Width = 150
      end
      item
        Width = 115
      end
      item
        Width = 120
      end
      item
        Width = 50
      end>
    object JvLED1: TJvLED
      Left = 3
      Top = 3
      Height = 15
      Status = False
    end
  end
  object pgc1: TPageControl
    Left = 0
    Top = 0
    Width = 886
    Height = 448
    ActivePage = ts1
    Align = alClient
    TabOrder = 1
    object ts1: TTabSheet
      Caption = 'Progress'
      object cxGrid2: TcxGrid
        Left = 0
        Top = 0
        Width = 873
        Height = 369
        BevelKind = bkFlat
        TabOrder = 0
        object cxGrid2DBCardView1: TcxGridDBCardView
          NavigatorButtons.ConfirmDelete = False
          DataController.DataSource = dsSearches
          DataController.Summary.DefaultGroupSummaryItems = <>
          DataController.Summary.FooterSummaryItems = <>
          DataController.Summary.SummaryGroups = <>
          OptionsData.Editing = False
          OptionsView.CardWidth = 255
          object cxGrid2DBCardView1id: TcxGridDBCardViewRow
            DataBinding.FieldName = 'id'
            CaptionAlignmentHorz = taRightJustify
            Options.Editing = False
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1enabled: TcxGridDBCardViewRow
            DataBinding.FieldName = 'enabled'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = False
          end
          object cxGrid2DBCardView1name: TcxGridDBCardViewRow
            Caption = 'Search name'
            DataBinding.FieldName = 'name'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1keywords: TcxGridDBCardViewRow
            Caption = 'Keywords'
            DataBinding.FieldName = 'keywords'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1CategoryID: TcxGridDBCardViewRow
            Caption = 'Category ID'
            DataBinding.FieldName = 'CategoryID'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1CategoryName: TcxGridDBCardViewRow
            Caption = 'Category Name'
            DataBinding.FieldName = 'CategoryName'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1LocatedIn1: TcxGridDBCardViewRow
            Caption = 'Located In'
            DataBinding.FieldName = 'LocatedIn'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1GlobalSiteID1: TcxGridDBCardViewRow
            DataBinding.FieldName = 'GlobalSiteID'
            CaptionAlignmentHorz = taRightJustify
            Options.Editing = False
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1TotalPages1: TcxGridDBCardViewRow
            Caption = 'Pages Total'
            DataBinding.FieldName = 'TotalPages'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1LoadedPages1: TcxGridDBCardViewRow
            Caption = 'Loaded'
            DataBinding.FieldName = 'LoadedPages'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = False
          end
          object cxGrid2DBCardView1TotalItems1: TcxGridDBCardViewRow
            Caption = 'Items Total'
            DataBinding.FieldName = 'TotalItems'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1LoadedItems1: TcxGridDBCardViewRow
            Caption = 'Loaded'
            DataBinding.FieldName = 'LoadedItems'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = False
          end
          object cxGrid2DBCardView1SavedItems1: TcxGridDBCardViewRow
            Caption = 'Items saved'
            DataBinding.FieldName = 'SavedItems'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1Row1: TcxGridDBCardViewRow
            DataBinding.FieldName = 'Progress'
            PropertiesClassName = 'TcxProgressBarProperties'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
          object cxGrid2DBCardView1Row2: TcxGridDBCardViewRow
            Caption = 'State'
            PropertiesClassName = 'TcxImageProperties'
            CaptionAlignmentHorz = taRightJustify
            Position.BeginsLayer = True
          end
        end
        object lvItemsCardGrid2Level1: TcxGridLevel
          GridView = cxGrid2DBCardView1
        end
      end
    end
    object ts4: TTabSheet
      Caption = 'Ebay Search result '
      ImageIndex = 3
      object cxgrd1: TcxGrid
        Left = 0
        Top = 0
        Width = 878
        Height = 420
        Align = alClient
        TabOrder = 0
        object btvcxgrd1DBBandedTableView1: TcxGridDBBandedTableView
          NavigatorButtons.ConfirmDelete = False
          DataController.DataSource = dsItems1
          DataController.Summary.DefaultGroupSummaryItems = <>
          DataController.Summary.FooterSummaryItems = <>
          DataController.Summary.SummaryGroups = <>
          Bands = <
            item
              Caption = 'Item'
              Width = 208
            end
            item
              Caption = 'Image'
              Width = 74
            end
            item
              Caption = 'Price'
              Width = 87
            end
            item
              Caption = 'Currency'
              Width = 49
            end
            item
              Caption = 'Other'
              Width = 109
            end
            item
              Caption = 'Time frame'
              Width = 72
            end
            item
              Caption = 'Search info'
              Width = 84
            end
            item
              Caption = 'URLs'
              Width = 183
            end>
          object btvcxgrd1DBBandedTableView1id: TcxGridDBBandedColumn
            DataBinding.FieldName = 'id'
            Options.Editing = False
            Position.BandIndex = 0
            Position.ColIndex = 0
            Position.RowIndex = 0
          end
          object btvcxgrd1DBBandedTableView1ItemID: TcxGridDBBandedColumn
            Caption = 'Item ID'
            DataBinding.FieldName = 'ItemID'
            Options.Editing = False
            Position.BandIndex = 0
            Position.ColIndex = 1
            Position.RowIndex = 0
          end
          object btvcxgrd1DBBandedTableView1ItemTitle: TcxGridDBBandedColumn
            Caption = 'Item Title'
            DataBinding.FieldName = 'ItemTitle'
            Options.Editing = False
            Position.BandIndex = 0
            Position.ColIndex = 0
            Position.LineCount = 2
            Position.RowIndex = 1
          end
          object btvcxgrd1DBBandedTableView1URL: TcxGridDBBandedColumn
            DataBinding.FieldName = 'URL'
            PropertiesClassName = 'TcxHyperLinkEditProperties'
            Options.Editing = False
            Position.BandIndex = 7
            Position.ColIndex = 0
            Position.RowIndex = 0
          end
          object btvcxgrd1DBBandedTableView1Price: TcxGridDBBandedColumn
            DataBinding.FieldName = 'Price'
            Options.Editing = False
            Position.BandIndex = 2
            Position.ColIndex = 0
            Position.RowIndex = 0
          end
          object btvcxgrd1DBBandedTableView1PriceCurrency: TcxGridDBBandedColumn
            DataBinding.FieldName = 'PriceCurrency'
            Options.Editing = False
            Options.CellMerging = True
            Options.ShowCaption = False
            Position.BandIndex = 3
            Position.ColIndex = 0
            Position.RowIndex = 0
            IsCaptionAssigned = True
          end
          object btvcxgrd1DBBandedTableView1BuyItNowPrice: TcxGridDBBandedColumn
            Caption = 'BuyItNow Price'
            DataBinding.FieldName = 'BuyItNowPrice'
            Options.Editing = False
            Position.BandIndex = 2
            Position.ColIndex = 0
            Position.RowIndex = 1
          end
          object btvcxgrd1DBBandedTableView1BuyItNowCurrency: TcxGridDBBandedColumn
            DataBinding.FieldName = 'BuyItNowCurrency'
            Options.Editing = False
            Options.CellMerging = True
            Options.ShowCaption = False
            Position.BandIndex = 3
            Position.ColIndex = 0
            Position.RowIndex = 1
            IsCaptionAssigned = True
          end
          object btvcxgrd1DBBandedTableView1SellerID: TcxGridDBBandedColumn
            Caption = 'Seller ID'
            DataBinding.FieldName = 'SellerID'
            Options.Editing = False
            Position.BandIndex = 4
            Position.ColIndex = 0
            Position.RowIndex = 0
          end
          object btvcxgrd1DBBandedTableView1ItemLocation: TcxGridDBBandedColumn
            Caption = 'Item Location'
            DataBinding.FieldName = 'ItemLocation'
            Options.Editing = False
            Position.BandIndex = 4
            Position.ColIndex = 0
            Position.RowIndex = 2
          end
          object btvcxgrd1DBBandedTableView1ShippingCost: TcxGridDBBandedColumn
            Caption = 'Shipping Cost'
            DataBinding.FieldName = 'ShippingCost'
            Options.Editing = False
            Position.BandIndex = 2
            Position.ColIndex = 0
            Position.RowIndex = 2
          end
          object btvcxgrd1DBBandedTableView1ShippingCostCurrency: TcxGridDBBandedColumn
            DataBinding.FieldName = 'ShippingCostCurrency'
            Options.Editing = False
            Options.CellMerging = True
            Options.ShowCaption = False
            Position.BandIndex = 3
            Position.ColIndex = 0
            Position.RowIndex = 2
            IsCaptionAssigned = True
          end
          object btvcxgrd1DBBandedTableView1GalleryImageURL: TcxGridDBBandedColumn
            Caption = 'Gallery Image URL'
            DataBinding.FieldName = 'GalleryImageURL'
            PropertiesClassName = 'TcxHyperLinkEditProperties'
            Options.Editing = False
            Position.BandIndex = 7
            Position.ColIndex = 0
            Position.RowIndex = 1
          end
          object btvcxgrd1DBBandedTableView1GalleryImage: TcxGridDBBandedColumn
            DataBinding.FieldName = 'GalleryImage'
            Options.Editing = False
            Position.BandIndex = 1
            Position.ColIndex = 0
            Position.LineCount = 3
            Position.RowIndex = 0
          end
          object btvcxgrd1DBBandedTableView1StartTime: TcxGridDBBandedColumn
            Caption = 'Start'
            DataBinding.FieldName = 'StartTime'
            Options.Editing = False
            Position.BandIndex = 5
            Position.ColIndex = 0
            Position.RowIndex = 0
          end
          object btvcxgrd1DBBandedTableView1EndTime: TcxGridDBBandedColumn
            Caption = 'End'
            DataBinding.FieldName = 'EndTime'
            Options.Editing = False
            Position.BandIndex = 5
            Position.ColIndex = 0
            Position.RowIndex = 1
          end
          object btvcxgrd1DBBandedTableView1ListingType: TcxGridDBBandedColumn
            Caption = 'Listing Type'
            DataBinding.FieldName = 'ListingType'
            Options.Editing = False
            Position.BandIndex = 4
            Position.ColIndex = 0
            Position.RowIndex = 1
          end
          object btvcxgrd1DBBandedTableView1SearchID: TcxGridDBBandedColumn
            DataBinding.FieldName = 'SearchID'
            Options.Editing = False
            Position.BandIndex = 6
            Position.ColIndex = 0
            Position.RowIndex = 0
          end
          object btvcxgrd1DBBandedTableView1Updated: TcxGridDBBandedColumn
            DataBinding.FieldName = 'Updated'
            Options.Editing = False
            Position.BandIndex = 6
            Position.ColIndex = 0
            Position.RowIndex = 1
          end
        end
        object lvItemsCardGrid3Level1: TcxGridLevel
          GridView = btvcxgrd1DBBandedTableView1
        end
      end
    end
    object ts2: TTabSheet
      Caption = 'Log'
      ImageIndex = 1
      object LogMemo: TMemo
        Left = 0
        Top = 0
        Width = 878
        Height = 383
        Align = alClient
        TabOrder = 0
      end
      object jvftr1: TJvFooter
        Left = 0
        Top = 383
        Width = 878
        Height = 37
        Align = alBottom
        BevelVisible = True
      end
    end
  end
  object con1: TADOConnection
    ConnectionString = 
      'Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=%s;Mo' +
      'de=Share Deny None;Extended Properties="";Jet OLEDB:System datab' +
      'ase="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password=""' +
      ';Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet O' +
      'LEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transaction' +
      's=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System D' +
      'atabase=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Compact' +
      ' Without Replica Repair=False;Jet OLEDB:SFP=False'
    LoginPrompt = False
    Provider = 'Microsoft.Jet.OLEDB.4.0'
    AfterConnect = con1AfterConnect
    AfterDisconnect = con1AfterConnect
    Left = 92
    Top = 400
  end
  object con2: TADOConnection
    Connected = True
    ConnectionString = 
      'Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\co' +
      'degear\projects\ebayfind\data\finditems.mdb;Mode=Share Deny None' +
      ';Extended Properties="";Persist Security Info=False;Jet OLEDB:Sy' +
      'stem database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database P' +
      'assword="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mo' +
      'de=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk T' +
      'ransactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Creat' +
      'e System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLE' +
      'DB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False'
    LoginPrompt = False
    Mode = cmShareDenyNone
    Provider = 'Microsoft.Jet.OLEDB.4.0'
    AfterConnect = con1AfterConnect
    AfterDisconnect = con1AfterConnect
    Left = 508
    Top = 392
  end
  object MainMenu1: TMainMenu
    Left = 16
    Top = 400
    object File1: TMenuItem
      Caption = 'File'
      object Export1: TMenuItem
        Caption = 'Export'
      end
      object N2: TMenuItem
        Caption = '-'
      end
      object Exit1: TMenuItem
        Action = actExit
      end
    end
    object Actions1: TMenuItem
      Caption = 'Actions'
      object Makesearch1: TMenuItem
        Action = actMakeSearch
      end
      object N3: TMenuItem
        Caption = '-'
      end
      object EditSearches1: TMenuItem
        Action = actShowSearchesEditor
      end
      object Checkcategories1: TMenuItem
        Action = actCheckCategories
      end
      object Downloadcategories1: TMenuItem
        Action = actDownloadCategories
      end
      object N4: TMenuItem
        Caption = '-'
      end
      object ClearSearchResults1: TMenuItem
        Action = actClearItemsTable
      end
    end
    object Settings1: TMenuItem
      Caption = 'Settings'
      object Programsettings1: TMenuItem
        Action = actSettings
        Caption = 'Program settings'
      end
      object Searches1: TMenuItem
        Action = actShowSearchesEditor
      end
    end
    object View1: TMenuItem
      Caption = 'View'
      object Log1: TMenuItem
        Action = actViewLog
      end
    end
    object N1: TMenuItem
      Action = actAbout
      Caption = '?'
    end
  end
  object ActionList1: TActionList
    Left = 56
    Top = 400
    object actExit: TAction
      Caption = 'Exit'
      OnExecute = actExitExecute
    end
    object actSearch: TAction
      Caption = 'Make search'
      OnExecute = actSearchExecute
    end
    object actAbout: TAction
      Caption = 'About'
      OnExecute = actAboutExecute
    end
    object actSettings: TAction
      Caption = 'Settings'
      OnExecute = actSettingsExecute
    end
    object actCheckCategories: TAction
      Caption = 'Check categories'
      OnExecute = actCheckCategoriesExecute
    end
    object actShowSearchesEditor: TAction
      Caption = 'Edit Searches'
      OnExecute = actShowSearchesEditorExecute
    end
    object actDownloadCategories: TAction
      Caption = 'Download categories'
      OnExecute = actDownloadCategoriesExecute
    end
    object actViewLog: TAction
      Caption = 'Advanced log'
      OnExecute = actViewLogExecute
    end
    object actMakeSearch: TAction
      Caption = 'Make search'
      OnExecute = actMakeSearchExecute
    end
    object actClearItemsTable: TAction
      Caption = 'Clear Search Results'
      OnExecute = actClearItemsTableExecute
    end
  end
  object tmr1: TTimer
    Left = 128
    Top = 368
  end
  object EbayShoppingConnect2: TEbayShoppingConnect
    AppID = 'PRESTOJ16H32DKB9J858R57FJ254J1'
    ProxyParameters.BasicAuthentication = False
    ProxyParameters.ProxyPort = 0
    GatewayURI = 'http://open.api.ebay.com/shopping?'
    SiteID = US
    Left = 656
    Top = 432
  end
  object GetCategoryInfo1: TGetCategoryInfo
    Connector = EbayShoppingConnect2
    OnEndRequest = GetCategoryInfo1EndRequest
    CategoryID = '-1'
    IncludeSelector = []
    Left = 696
    Top = 432
  end
  object JvSaveDialog1: TJvSaveDialog
    Height = 419
    Width = 563
    Left = 204
    Top = 368
  end
  object tblCategories: TADOTable
    Connection = con1
    CursorType = ctStatic
    TableName = 'Categories'
    Left = 412
    Top = 391
    object tblCategoriesCategoryID: TWideStringField
      FieldName = 'CategoryID'
    end
    object tblCategoriesCategoryLevel: TIntegerField
      FieldName = 'CategoryLevel'
    end
    object tblCategoriesCategoryName: TWideStringField
      FieldName = 'CategoryName'
      Size = 100
    end
    object tblCategoriesCategoryParentID: TWideStringField
      FieldName = 'CategoryParentID'
    end
    object tblCategoriesLeafCategory: TBooleanField
      FieldName = 'LeafCategory'
    end
  end
  object tblItemDetails: TADOTable
    Connection = con1
    CursorType = ctStatic
    IndexFieldNames = 'ItemTitle'
    MasterFields = 'ItemTitle'
    MasterSource = dsItems
    TableName = 'Items'
    Left = 244
    Top = 399
    object tblItemDetailsid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object wdstrngfldItemDetailsItemID: TWideStringField
      FieldName = 'ItemID'
      Size = 38
    end
    object wdstrngfldItemDetailsItemTitle: TWideStringField
      FieldName = 'ItemTitle'
      Size = 255
    end
    object wdstrngfldItemDetailsURL: TWideStringField
      FieldName = 'URL'
      Size = 255
    end
    object wdstrngfldItemDetailsCondition: TWideStringField
      FieldName = 'Condition'
    end
    object tblItemDetailsPrice: TIntegerField
      FieldName = 'Price'
    end
    object wdstrngfldItemDetailsPriceCurrency: TWideStringField
      FieldName = 'PriceCurrency'
      Size = 3
    end
    object tblItemDetailsBuyItNowPrice: TIntegerField
      FieldName = 'BuyItNowPrice'
    end
    object wdstrngfldItemDetailsBuyItNowCurrency: TWideStringField
      FieldName = 'BuyItNowCurrency'
      Size = 3
    end
    object wdstrngfldItemDetailsSellerID: TWideStringField
      FieldName = 'SellerID'
      Size = 60
    end
    object wdstrngfldItemDetailsItemLocation: TWideStringField
      FieldName = 'ItemLocation'
      Size = 100
    end
    object tblItemDetailsShippingCost: TIntegerField
      FieldName = 'ShippingCost'
    end
    object wdstrngfldItemDetailsShippingCostCurrency: TWideStringField
      FieldName = 'ShippingCostCurrency'
      Size = 3
    end
    object wdstrngfldItemDetailsGalleryImageURL: TWideStringField
      FieldName = 'GalleryImageURL'
      Size = 255
    end
    object tblItemDetailsGalleryImage: TBlobField
      FieldName = 'GalleryImage'
    end
    object dtmfldItemDetailsStartTime: TDateTimeField
      FieldName = 'StartTime'
    end
    object dtmfldItemDetailsEndTime: TDateTimeField
      FieldName = 'EndTime'
    end
    object wdstrngfldItemDetailsListingType: TWideStringField
      FieldName = 'ListingType'
    end
  end
  object tblCountries: TADOTable
    Connection = con1
    CursorType = ctStatic
    TableName = 'Countries'
    Left = 460
    Top = 400
    object tblCountriesid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object tblCountriesName: TWideStringField
      FieldName = 'Name'
      Size = 255
    end
    object tblCountriesCode: TWideStringField
      FieldName = 'Code'
      Size = 255
    end
  end
  object dsSearches: TDataSource
    DataSet = qrySearches
    Left = 540
    Top = 368
  end
  object dsItemsDetails: TDataSource
    DataSet = tblItemDetails
    Left = 244
    Top = 376
  end
  object qryItems: TADOQuery
    Connection = con1
    CursorType = ctStatic
    AfterOpen = qryItemsAfterOpen
    BeforeClose = qryItemsBeforeClose
    Parameters = <>
    Prepared = True
    SQL.Strings = (
      
        'select ItemTitle, avg(Price) as AvgPrice, count(id) as quantity ' +
        'from Items group by ItemTitle')
    Left = 332
    Top = 400
  end
  object dsItems: TDataSource
    DataSet = qryItems
    Left = 332
    Top = 376
  end
  object dsCountries: TDataSource
    DataSet = tblCountries
    Left = 460
    Top = 368
  end
  object tblSites: TADOTable
    Connection = con1
    CursorType = ctStatic
    TableName = 'Sites'
    Left = 380
    Top = 400
    object wdstrngfldSitesGlobalSiteID: TWideStringField
      FieldName = 'GlobalSiteID'
    end
    object tblSitesEnabled: TBooleanField
      FieldName = 'Enabled'
    end
    object tblSitesVersion: TIntegerField
      FieldName = 'Version'
    end
    object dtmfldSitesLastUpdated: TDateTimeField
      FieldName = 'LastUpdated'
    end
    object wdstrngfldSitesComment: TWideStringField
      FieldName = 'Comment'
      Size = 50
    end
  end
  object dsSites: TDataSource
    DataSet = tblSites
    Left = 380
    Top = 376
  end
  object qryActiveSites: TADOQuery
    Connection = con1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from sites where Enabled = true')
    Left = 284
    Top = 400
    object wdstrngfldActiveSitesGlobalSiteID: TWideStringField
      FieldName = 'GlobalSiteID'
    end
    object qryActiveSitesEnabled: TBooleanField
      FieldName = 'Enabled'
    end
    object qryActiveSitesVersion: TIntegerField
      FieldName = 'Version'
    end
    object dtmfldActiveSitesLastUpdated: TDateTimeField
      FieldName = 'LastUpdated'
    end
    object wdstrngfldActiveSitesComment: TWideStringField
      FieldName = 'Comment'
      Size = 50
    end
  end
  object tmrCategories: TTimer
    Enabled = False
    OnTimer = tmrCategoriesTimer
    Left = 172
    Top = 384
  end
  object qrySearches: TADOQuery
    Active = True
    Connection = con2
    CursorType = ctStatic
    AfterOpen = qrySearchesAfterOpen
    OnCalcFields = qrySearchesCalcFields
    Parameters = <>
    SQL.Strings = (
      'select * from Searches where enabled = true')
    Left = 548
    Top = 392
    object qrySearchesid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object qrySearchesenabled: TBooleanField
      FieldName = 'enabled'
    end
    object wdstrngfldSearchesname: TWideStringField
      FieldName = 'name'
      Size = 50
    end
    object wdstrngfldSearcheskeywords: TWideStringField
      FieldName = 'keywords'
      Size = 100
    end
    object wdstrngfldSearchesCategoryID: TWideStringField
      FieldName = 'CategoryID'
    end
    object wdstrngfldSearchesCategoryName: TWideStringField
      FieldName = 'CategoryName'
      Size = 100
    end
    object wdstrngfldSearchesAvailableTo: TWideStringField
      FieldName = 'AvailableTo'
      Size = 2
    end
    object wdstrngfldSearchesCondition: TWideStringField
      FieldName = 'Condition'
      Size = 4
    end
    object wdstrngfldSearchesCurrency: TWideStringField
      FieldName = 'Currency'
      Size = 3
    end
    object dtmfldSearchesEndTimeFrom: TDateTimeField
      FieldName = 'EndTimeFrom'
    end
    object dtmfldSearchesEndTimeTo: TDateTimeField
      FieldName = 'EndTimeTo'
    end
    object qrySearchesExcludeAutoPay: TBooleanField
      FieldName = 'ExcludeAutoPay'
    end
    object wdstrngfldSearchesExcludeSeller: TWideStringField
      FieldName = 'ExcludeSeller'
      Size = 255
    end
    object qrySearchesFeaturedOnly: TBooleanField
      FieldName = 'FeaturedOnly'
    end
    object qrySearchesFeedbackScoreMax: TIntegerField
      FieldName = 'FeedbackScoreMax'
    end
    object qrySearchesFeedbackScoreMin: TIntegerField
      FieldName = 'FeedbackScoreMin'
    end
    object qrySearchesFreeShippingOnly: TBooleanField
      FieldName = 'FreeShippingOnly'
    end
    object qrySearchesGetItFastOnly: TBooleanField
      FieldName = 'GetItFastOnly'
    end
    object qrySearchesHideDuplicateItems: TBooleanField
      FieldName = 'HideDuplicateItems'
    end
    object wdstrngfldSearchesListingType: TWideStringField
      FieldName = 'ListingType'
      Size = 255
    end
    object qrySearchesLocalPickupOnly: TBooleanField
      FieldName = 'LocalPickupOnly'
    end
    object qrySearchesLocalSearchOnly: TBooleanField
      FieldName = 'LocalSearchOnly'
    end
    object wdstrngfldSearchesLocatedIn: TWideStringField
      FieldName = 'LocatedIn'
      Size = 2
    end
    object qrySearchesLotsOnly: TBooleanField
      FieldName = 'LotsOnly'
    end
    object qrySearchesMaxBids: TIntegerField
      FieldName = 'MaxBids'
    end
    object qrySearchesMaxDistance: TIntegerField
      FieldName = 'MaxDistance'
    end
    object qrySearchesMaxPrice: TIntegerField
      FieldName = 'MaxPrice'
    end
    object qrySearchesMaxQuantity: TIntegerField
      FieldName = 'MaxQuantity'
    end
    object qrySearchesMinBids: TIntegerField
      FieldName = 'MinBids'
    end
    object qrySearchesMinPrice: TIntegerField
      FieldName = 'MinPrice'
    end
    object wdstrngfldSearchesMinMaxPriceCurrency: TWideStringField
      FieldName = 'MinMaxPriceCurrency'
      Size = 3
    end
    object qrySearchesMinQuantity: TIntegerField
      FieldName = 'MinQuantity'
    end
    object wdstrngfldSearchesPaymentMethod: TWideStringField
      FieldName = 'PaymentMethod'
      Size = 50
    end
    object wdstrngfldSearchesSeller: TWideStringField
      FieldName = 'Seller'
      Size = 255
    end
    object wdstrngfldSearchesSellerBusinessType: TWideStringField
      FieldName = 'SellerBusinessType'
      Size = 50
    end
    object qrySearchesTopRatedSellerOnly: TBooleanField
      FieldName = 'TopRatedSellerOnly'
    end
    object qrySearchesWorldOfGoodOnly: TBooleanField
      FieldName = 'WorldOfGoodOnly'
    end
    object wdstrngfldSearchesBuyerPostalCode: TWideStringField
      FieldName = 'BuyerPostalCode'
    end
    object wdstrngfldSearchesGlobalSiteID: TWideStringField
      FieldName = 'GlobalSiteID'
    end
    object qrySearchesTotalPages: TIntegerField
      FieldKind = fkCalculated
      FieldName = 'TotalPages'
      Calculated = True
    end
    object qrySearchesLoadedPages: TIntegerField
      FieldKind = fkCalculated
      FieldName = 'LoadedPages'
      Calculated = True
    end
    object qrySearchesTotalItems: TIntegerField
      FieldKind = fkCalculated
      FieldName = 'TotalItems'
      Calculated = True
    end
    object qrySearchesLoadedItems: TIntegerField
      FieldKind = fkCalculated
      FieldName = 'LoadedItems'
      Calculated = True
    end
    object qrySearchesSavedItems: TIntegerField
      FieldKind = fkCalculated
      FieldName = 'SavedItems'
      Calculated = True
    end
    object qrySearchesThreadID: TIntegerField
      FieldKind = fkCalculated
      FieldName = 'ThreadID'
      Calculated = True
    end
    object qrySearchesProgress: TIntegerField
      FieldKind = fkCalculated
      FieldName = 'Progress'
      Calculated = True
    end
  end
  object dsActiveSites: TDataSource
    DataSet = qryActiveSites
    Left = 284
    Top = 376
  end
  object qryDelItems: TADOQuery
    Connection = con1
    Parameters = <>
    SQL.Strings = (
      'delete from items')
    Left = 140
    Top = 400
  end
  object tblItems: TADOTable
    Connection = con1
    TableName = 'Items'
    Left = 44
    Top = 352
    object atncfldItemsid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object wdstrngfldItemsItemID: TWideStringField
      FieldName = 'ItemID'
      Size = 38
    end
    object wdstrngfldItemsItemTitle: TWideStringField
      FieldName = 'ItemTitle'
      Size = 255
    end
    object wdstrngfldItemsURL: TWideStringField
      FieldName = 'URL'
      Size = 255
    end
    object wdstrngfldItemsCondition: TWideStringField
      FieldName = 'Condition'
    end
    object tblItemsPrice: TIntegerField
      FieldName = 'Price'
    end
    object wdstrngfldItemsPriceCurrency: TWideStringField
      FieldName = 'PriceCurrency'
      Size = 3
    end
    object tblItemsBuyItNowPrice: TIntegerField
      FieldName = 'BuyItNowPrice'
    end
    object wdstrngfldItemsBuyItNowCurrency: TWideStringField
      FieldName = 'BuyItNowCurrency'
      Size = 3
    end
    object wdstrngfldItemsSellerID: TWideStringField
      FieldName = 'SellerID'
      Size = 60
    end
    object wdstrngfldItemsItemLocation: TWideStringField
      FieldName = 'ItemLocation'
      Size = 100
    end
    object tblItemsShippingCost: TIntegerField
      FieldName = 'ShippingCost'
    end
    object wdstrngfldItemsShippingCostCurrency: TWideStringField
      FieldName = 'ShippingCostCurrency'
      Size = 3
    end
    object wdstrngfldItemsGalleryImageURL: TWideStringField
      FieldName = 'GalleryImageURL'
      Size = 255
    end
    object blbfldItemsGalleryImage: TBlobField
      FieldName = 'GalleryImage'
    end
    object dtmfldItemsStartTime: TDateTimeField
      FieldName = 'StartTime'
    end
    object dtmfldItemsEndTime: TDateTimeField
      FieldName = 'EndTime'
    end
    object wdstrngfldItemsListingType: TWideStringField
      FieldName = 'ListingType'
    end
    object tblItemsSearchID: TIntegerField
      FieldName = 'SearchID'
    end
    object dtmfldItemsUpdated: TDateTimeField
      FieldName = 'Updated'
    end
  end
  object dsItems1: TDataSource
    DataSet = tblItems
    Left = 44
    Top = 312
  end
  object cxstylrpstry1: TcxStyleRepository
    PixelsPerInch = 96
    object cxstyl1: TcxStyle
    end
  end
end
